ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Multi-Select searchable drop-down in Bootstrap 5

Multi-select drop-down with search in Bootstrap 5 From

multi-select-dropdown-with-search-in-bootstrap-5.zip

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

Drodown-popup-Button.zip

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...